package com.hos.db.create.user;

/**
 * 医生信息
 * Created by guom on 2018/10/15.
 */
public class UserDocTable {
    public static String tableName = "user_docs";
    public static String tableId = "id";
    public static String tableDocId = "doc_id";// id
    public static String tableDocName = "doc_name";// 姓名
    public static String tableDocPhone = "doc_phone";// 手机号
    public static String tableDocAccount = "doc_account";// 账号
    public static String tableDocPwd = "doc_pwd";// 密码
    public static String tableDocNickname = "doc_nickname";// 昵称
    public static String tableDocPortrait = "doc_portrait";// 头像
    public static String tableDocRegisterTime = "doc_register_time";// 注册时间
    public static String tableDocBirthday = "doc_birthday";// 生日
    public static String tableDocSex = "doc_sex";// 性别
    public static String tableDocIdentityNumber = "doc_identity_number";// 身份证
    public static String tableDocAddress = "doc_address";// 地址
    public static String tableDocPushId = "doc_pushid";//推送id
    public static String tableDocDevice = "doc_device";//设备
    public static String tableDocLoninTime = "doc_login_time";// 登录时间
    public static String tableDocToken = "doc_token";
    //状态 1：待审核状态 2：审核通过状态
    public static String tableDocState = "doc_state";
    //医生职称
    public static String tableDocTitle = "doc_title";
    //医生医院
    public static String tableDocHosName = "doc_hos_name";
    public static String tableDocHosId = "doc_hos_id";
    //医生科室
    public static String tableDocDeptName = "doc_dept_name";
    public static String tableDocDeptId = "doc_dept_id";
    //医生工作年限
    public static String tableDocWorkYear = "doc_work_year";
    //医生权利
    public static String tableDocPower = "doc_power";
    public static String tableDocWXId = "doc_wx_id";//医生微信id
    public static String tableDocJS = "doc_js";//医生介绍
    public static String tableDocSC = "doc_sc";//医生擅长
    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableId + "  int, "
            + tableDocId + " varchar(100), "
            + tableDocName + " varchar(100), "
            + tableDocPhone + " varchar(100), "
            + tableDocAccount + " varchar(100) primary key, "//主键
            + tableDocPwd + " varchar(100), "
            + tableDocNickname + " varchar(100), "
            + tableDocPortrait + " varchar(100), "
            + tableDocRegisterTime + " datetime, "
            + tableDocBirthday + " varchar(100), "
            + tableDocSex + " varchar(100), "
            + tableDocIdentityNumber + " varchar(100), "
            + tableDocAddress + " varchar(100), "
            + tableDocState + " int, "
            + tableDocPushId + " varchar(100), "
            + tableDocDevice + " varchar(100), "
            + tableDocTitle + " varchar(100), "
            + tableDocHosName + " varchar(100), "
            + tableDocHosId + " varchar(100), "
            + tableDocDeptName + " varchar(100), "
            + tableDocDeptId + " varchar(100), "
            + tableDocWorkYear + " varchar(100), "
            + tableDocPower + " int, "
            + tableDocToken + " varchar(100), "
            + tableDocWXId + " varchar(100), "
            + tableDocJS + " varchar(200), "
            + tableDocSC + " varchar(200), "
            + tableDocLoninTime + " varchar(100) "
            + "); ";

}
